Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vtokctcashclose.sql

Text File | 2000-05-12 | 369b | 9 lines

CREATE OR REPLACE VIEW VTOKCTCASHCLOSE AS
SELECT CASHCLOSE.PRPEND_INDX, CASHCLOSE.LAST_CURSTATE,
SUM(DECODE(currency_type, 250, reset_count, 0)) sm_tokens,
SUM(DECODE(currency_type, 251, reset_count, 0)) lg_tokens
FROM CASHCLOSE, CSCURCNT
WHERE CSCURCNT.det_seq_num = CASHCLOSE.LAST_CURSTATE
GROUP BY CASHCLOSE.PRPEND_INDX, CASHCLOSE.LAST_CURSTATE;